Menu Price file Import

Introduction

This will import vehicle file to Cloud SQL for PostgreSQL

Fields

Column Position	Description	Datatype	Validation	Max length	Mandatory	Example
A	IGNORE
B	IGNORE
C	Vehicle Id	Number	Numbers (0-9)	5	Y	1
D	Repair short desc	String	A-Z characters	20	Y	Brakes
E	Repair desc 1	String	A-Z and 0-9 & All Special Characters	100	Y	Renew Front Brake Pads
F	Repair desc 2	String	A-Z and 0-9 & All Special Characters	100	Y	Standard
G	Labour Time	Number	upto 2 decimals	4	Y	0.8
H	Part number	String	A-Z and 0-9 & All Special Characters	50	Y	1678168380
I	Part Name	String	A-Z and 0-9 & All Special Characters	100	Y	Brake Pads
J	Part price	Number	upto 2 decimals	7	Y	78.3
K	Part/fluid qty	Number	upto 2 decimals	5	Y	1
L	IGNORE
M	Additional notes for parts	String	A-Z and 0-9 & All Special Characters	300	N	Some notes

Importing a file

Preparation

1. Upload the file with filename as menu_price.csv into fnp-imports/modulus storage bucket

Validation

1. Go to Cloud Scheduler
2. Run Modulus_menu_price_validation job (job name could be different on other env)

Importing

1. Go to Cloud Scheduler
2. Run Modulus_menu_price_import job (job name could be different on other env)

Testing

1. Data will be inserted to Cloud SQL for PostgreSQL under fpn database in table modulus_menu_price.

Status: Accepted
Category: Protected
Authored By: Gladson on Jan 5, 2024

Revisions